SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 51340: Expressions in computed columns might not be saved for SAS® IT Resource Management staged or aggregation tables

DetailsAboutRate It

In SAS IT Resource Management, staged and aggregation tables contain computed columns for data that is not directly provided by the raw data source. After you enter an expression once in computed column in these tables, the expression might not be saved. Or, if you re-enter and save the expression, the computed column is no longer available to the staging or aggregation job table.

In order to define a computed-column expression, you must enter it twice. Then, subsequent to saving the staging or aggregation table with the new computed column, you must run, respectively, a staging or aggregation job. This action ensures that the computed column is created, saved, and populated.

For more information about computed columns, see the SAS® IT Resource Management 3.3: Administrator's Guide.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS IT Resource Management-ServerMicrosoft Windows 8 Pro 32-bit3.33.49.3 TS1M29.4 TS1M1
Microsoft Windows 8 Enterprise x643.33.49.3 TS1M29.4 TS1M1
Microsoft® Windows® for x643.33.49.3 TS1M29.4 TS1M1
Microsoft Windows 8 Enterprise 32-bit3.33.49.3 TS1M29.4 TS1M1
z/OS3.33.49.3 TS1M29.4 TS1M1
Microsoft Windows 8 Pro x643.33.49.3 TS1M29.4 TS1M1
Microsoft Windows Server 2003 Datacenter Edition3.39.3 TS1M2
Microsoft Windows Server 2003 Enterprise Edition3.39.3 TS1M2
Microsoft Windows Server 2003 Standard Edition3.39.3 TS1M2
Microsoft Windows Server 2003 for x643.39.3 TS1M2
Microsoft Windows Server 20083.39.3 TS1M2
Microsoft Windows Server 2008 R23.33.49.3 TS1M29.4 TS1M1
Microsoft Windows Server 2008 for x643.33.49.3 TS1M29.4 TS1M1
Microsoft Windows Server 2012 Datacenter3.33.49.3 TS1M29.4 TS1M1
Microsoft Windows Server 2012 Std3.33.49.3 TS1M29.4 TS1M1
Microsoft Windows XP Professional3.39.3 TS1M2
Windows 7 Enterprise 32 bit3.39.3 TS1M2
Windows 7 Enterprise x643.33.49.3 TS1M29.4 TS1M1
Windows 7 Home Premium 32 bit3.39.3 TS1M2
Windows 7 Home Premium x643.39.3 TS1M2
Windows 7 Professional 32 bit3.39.3 TS1M2
Windows 7 Professional x643.33.49.3 TS1M29.4 TS1M1
Windows 7 Ultimate 32 bit3.39.3 TS1M2
Windows 7 Ultimate x643.39.3 TS1M2
Windows Vista3.39.3 TS1M2
Windows Vista for x643.39.3 TS1M2
64-bit Enabled AIX3.33.49.3 TS1M29.4 TS1M1
64-bit Enabled HP-UX3.33.49.3 TS1M29.4 TS1M1
64-bit Enabled Solaris3.33.49.3 TS1M29.4 TS1M1
HP-UX IPF3.33.49.3 TS1M29.4 TS1M1
Linux3.33.49.3 TS1M29.4 TS1M1
Linux for x643.33.49.3 TS1M29.4 TS1M1
Solaris for x643.33.49.3 TS1M29.4 TS1M1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.